Profile Report of Alternative Fueling Station Data

Dataset statistics

Number of variables	19
Number of observations	1940
Missing cells	5441
Missing cells (%)	14.8%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	288.1 KiB
Average record size in memory	152.1 B

Variable types

Text	6
Categorical	5
Numeric	6
DateTime	2

Alerts

`State` has constant value ""	Constant
`EV Level1 EVSE Num` is highly overall correlated with `EV Level2 EVSE Num` and 1 other fields	High correlation
`EV Level2 EVSE Num` is highly overall correlated with `EV Level1 EVSE Num`	High correlation
`Groups With Access Code` is highly overall correlated with `Date Last Confirmed`	High correlation
`EV Network` is highly overall correlated with `EV Level1 EVSE Num` and 1 other fields	High correlation
`Date Last Confirmed` is highly overall correlated with `Groups With Access Code` and 1 other fields	High correlation
`Groups With Access Code` is highly imbalanced (90.5%)	Imbalance
`Date Last Confirmed` is highly imbalanced (64.9%)	Imbalance
`EV Connector Types` is highly imbalanced (67.5%)	Imbalance
`Access Days Time` has 162 (8.4%) missing values	Missing
`EV Level1 EVSE Num` has 1932 (99.6%) missing values	Missing
`EV Level2 EVSE Num` has 205 (10.6%) missing values	Missing
`EV DC Fast Count` has 1679 (86.5%) missing values	Missing
`EV Pricing` has 1460 (75.3%) missing values	Missing
`ID` has unique values	Unique

Reproduction

Analysis started	2023-10-12 07:41:28.834678
Analysis finished	2023-10-12 07:41:32.951601
Duration	4.12 seconds
Software version	ydata-profiling v0.0.dev0
Download configuration	config.json

Station Name
Text

Distinct	1928
Distinct (%)	99.4%
Missing	0
Missing (%)	0.0%
Memory size	15.3 KiB

Length

Max length	72
Median length	55
Mean length	23.430412
Min length	3

Characters and Unicode

Total characters	45455
Distinct characters	80
Distinct categories	11 ?
Distinct scripts	2 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1918 ?
Unique (%)	98.9%

Sample

1st row	City of Lacey - City Hall Parking
2nd row	Seattle-Tacoma International Airport - General Parking
3rd row	Avista Corp
4th row	Steam Plant Parking
5th row	BELLEVUE BELLEVUE CH 1

Value	Count	Frequency (%)
	477	5.9%
1	199	2.5%
amz	185	2.3%
tesla	161	2.0%
station	153	1.9%
2	142	1.8%
destination	113	1.4%
wa	79	1.0%
garage	78	1.0%
seattle	72	0.9%
Other values (1999)	6426	79.5%

Most occurring characters

Value	Count	Frequency (%)
	6151	13.5%
e	2368	5.2%
a	1882	4.1%
A	1856	4.1%
t	1541	3.4%
S	1511	3.3%
E	1484	3.3%
n	1447	3.2%
r	1362	3.0%
T	1330	2.9%
Other values (70)	24523	54.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	17762	39.1%
Lowercase Letter	17032	37.5%
Space Separator	6151	13.5%
Decimal Number	3324	7.3%
Dash Punctuation	603	1.3%
Other Punctuation	493	1.1%
Close Punctuation	39	0.1%
Open Punctuation	39	0.1%
Math Symbol	6	< 0.1%
Connector Punctuation	5	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	2368	13.9%
a	1882	11.0%
t	1541	9.0%
n	1447	8.5%
r	1362	8.0%
o	1236	7.3%
i	1209	7.1%
l	1180	6.9%
s	980	5.8%
u	474	2.8%
Other values (17)	3353	19.7%

Uppercase Letter

Value	Count	Frequency (%)
A	1856	10.4%
S	1511	8.5%
E	1484	8.4%
T	1330	7.5%
C	1137	6.4%
L	1019	5.7%
I	968	5.4%
N	926	5.2%
O	886	5.0%
R	854	4.8%
Other values (16)	5791	32.6%

Decimal Number

Value	Count	Frequency (%)
1	835	25.1%
2	614	18.5%
0	392	11.8%
4	335	10.1%
3	317	9.5%
5	246	7.4%
6	195	5.9%
9	154	4.6%
7	125	3.8%
8	111	3.3%

Other Punctuation

Value	Count	Frequency (%)
#	214	43.4%
,	98	19.9%
&	61	12.4%
.	47	9.5%
'	35	7.1%
:	25	5.1%
/	10	2.0%
\	2	0.4%
@	1	0.2%

Math Symbol

Value	Count	Frequency (%)
\|	4	66.7%
+	2	33.3%

Space Separator

Value	Count	Frequency (%)
	6151	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	603	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	39	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	39	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	5	100.0%

Final Punctuation

Value	Count	Frequency (%)
’	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	34794	76.5%
Common	10661	23.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	2368	6.8%
a	1882	5.4%
A	1856	5.3%
t	1541	4.4%
S	1511	4.3%
E	1484	4.3%
n	1447	4.2%
r	1362	3.9%
T	1330	3.8%
o	1236	3.6%
Other values (43)	18777	54.0%

Common

Value	Count	Frequency (%)
	6151	57.7%
1	835	7.8%
2	614	5.8%
-	603	5.7%
0	392	3.7%
4	335	3.1%
3	317	3.0%
5	246	2.3%
#	214	2.0%
6	195	1.8%
Other values (17)	759	7.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	45453	> 99.9%
None	1	< 0.1%
Punctuation	1	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	6151	13.5%
e	2368	5.2%
a	1882	4.1%
A	1856	4.1%
t	1541	3.4%
S	1511	3.3%
E	1484	3.3%
n	1447	3.2%
r	1362	3.0%
T	1330	2.9%
Other values (68)	24521	53.9%

None

Value	Count	Frequency (%)
é	1	100.0%

Punctuation

Value	Count	Frequency (%)
’	1	100.0%

Street Address
Text

Distinct	1326
Distinct (%)	68.4%
Missing	0
Missing (%)	0.0%
Memory size	15.3 KiB

Length

Max length	45
Median length	35
Mean length	17.373196
Min length	7

Characters and Unicode

Total characters	33704
Distinct characters	69
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1088 ?
Unique (%)	56.1%

Sample

1st row	420 College St
2nd row	17801 Pacific Hwy S
3rd row	1411 E Mission Ave
4th row	130 S Post St
5th row	450 110th Ave NE

Value	Count	Frequency (%)
ave	624	8.5%
ne	393	5.4%
st	378	5.2%
way	192	2.6%
n	153	2.1%
s	150	2.1%
se	124	1.7%
rd	120	1.6%
street	100	1.4%
avenue	97	1.3%
Other values (1718)	4984	68.1%

Most occurring characters

Value	Count	Frequency (%)
	5383	16.0%
e	2148	6.4%
1	2017	6.0%
t	1956	5.8%
0	1622	4.8%
a	1194	3.5%
2	1085	3.2%
r	1072	3.2%
S	1022	3.0%
v	935	2.8%
Other values (59)	15270	45.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	13997	41.5%
Decimal Number	8678	25.7%
Uppercase Letter	5447	16.2%
Space Separator	5383	16.0%
Other Punctuation	159	0.5%
Dash Punctuation	37	0.1%
Open Punctuation	1	< 0.1%
Close Punctuation	1	< 0.1%
Control	1	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	2148	15.3%
t	1956	14.0%
a	1194	8.5%
r	1072	7.7%
v	935	6.7%
h	840	6.0%
n	792	5.7%
o	783	5.6%
i	711	5.1%
l	695	5.0%
Other values (15)	2871	20.5%

Uppercase Letter

Value	Count	Frequency (%)
S	1022	18.8%
A	814	14.9%
N	698	12.8%
E	674	12.4%
W	509	9.3%
B	230	4.2%
R	205	3.8%
C	176	3.2%
D	165	3.0%
P	160	2.9%
Other values (14)	794	14.6%

Decimal Number

Value	Count	Frequency (%)
1	2017	23.2%
0	1622	18.7%
2	1085	12.5%
5	883	10.2%
3	737	8.5%
8	582	6.7%
4	538	6.2%
6	405	4.7%
7	405	4.7%
9	404	4.7%

Other Punctuation

Value	Count	Frequency (%)
.	132	83.0%
,	17	10.7%
&	7	4.4%
#	2	1.3%
/	1	0.6%

Space Separator

Value	Count	Frequency (%)
	5383	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	37	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	1	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	1	100.0%

Control

Value	Count	Frequency (%)
	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	19444	57.7%
Common	14260	42.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	2148	11.0%
t	1956	10.1%
a	1194	6.1%
r	1072	5.5%
S	1022	5.3%
v	935	4.8%
h	840	4.3%
A	814	4.2%
n	792	4.1%
o	783	4.0%
Other values (39)	7888	40.6%

Common

Value	Count	Frequency (%)
	5383	37.7%
1	2017	14.1%
0	1622	11.4%
2	1085	7.6%
5	883	6.2%
3	737	5.2%
8	582	4.1%
4	538	3.8%
6	405	2.8%
7	405	2.8%
Other values (10)	603	4.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	33704	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	5383	16.0%
e	2148	6.4%
1	2017	6.0%
t	1956	5.8%
0	1622	4.8%
a	1194	3.5%
2	1085	3.2%
r	1072	3.2%
S	1022	3.0%
v	935	2.8%
Other values (59)	15270	45.3%

City
Text

Distinct	210
Distinct (%)	10.8%
Missing	0
Missing (%)	0.0%
Memory size	15.3 KiB

Length

Max length	20
Median length	17
Mean length	7.8804124
Min length	2

Characters and Unicode

Total characters	15288
Distinct characters	53
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	80 ?
Unique (%)	4.1%

Sample

1st row	Lacey
2nd row	Seattle
3rd row	Spokane
4th row	Spokane
5th row	Bellevue

Value	Count	Frequency (%)
seattle	468	21.9%
bellevue	261	12.2%
tacoma	88	4.1%
spokane	66	3.1%
vancouver	45	2.1%
walla	42	2.0%
renton	39	1.8%
olympia	38	1.8%
bellingham	35	1.6%
kirkland	34	1.6%
Other values (223)	1018	47.7%

Most occurring characters

Value	Count	Frequency (%)
e	2654	17.4%
l	1679	11.0%
a	1541	10.1%
t	1292	8.5%
n	777	5.1%
o	725	4.7%
S	624	4.1%
u	564	3.7%
r	458	3.0%
i	444	2.9%
Other values (43)	4530	29.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	12902	84.4%
Uppercase Letter	2181	14.3%
Space Separator	194	1.3%
Other Punctuation	7	< 0.1%
Decimal Number	4	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	2654	20.6%
l	1679	13.0%
a	1541	11.9%
t	1292	10.0%
n	777	6.0%
o	725	5.6%
u	564	4.4%
r	458	3.5%
i	444	3.4%
v	391	3.0%
Other values (14)	2377	18.4%

Uppercase Letter

Value	Count	Frequency (%)
S	624	28.6%
B	387	17.7%
T	139	6.4%
L	110	5.0%
R	107	4.9%
W	105	4.8%
P	88	4.0%
V	70	3.2%
A	70	3.2%
E	69	3.2%
Other values (14)	412	18.9%

Decimal Number

Value	Count	Frequency (%)
0	2	50.0%
8	1	25.0%
9	1	25.0%

Space Separator

Value	Count	Frequency (%)
	194	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	7	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	15083	98.7%
Common	205	1.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	2654	17.6%
l	1679	11.1%
a	1541	10.2%
t	1292	8.6%
n	777	5.2%
o	725	4.8%
S	624	4.1%
u	564	3.7%
r	458	3.0%
i	444	2.9%
Other values (38)	4325	28.7%

Common

Value	Count	Frequency (%)
	194	94.6%
.	7	3.4%
0	2	1.0%
8	1	0.5%
9	1	0.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	15288	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	2654	17.4%
l	1679	11.0%
a	1541	10.1%
t	1292	8.5%
n	777	5.1%
o	725	4.7%
S	624	4.1%
u	564	3.7%
r	458	3.0%
i	444	2.9%
Other values (43)	4530	29.6%

State
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.3 KiB

WA	1940

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	3880
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	WA
2nd row	WA
3rd row	WA
4th row	WA
5th row	WA

Common Values

Value	Count	Frequency (%)
WA	1940	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
wa	1940	100.0%

Most occurring characters

Value	Count	Frequency (%)
W	1940	50.0%
A	1940	50.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	3880	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
W	1940	50.0%
A	1940	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3880	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
W	1940	50.0%
A	1940	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3880	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
W	1940	50.0%
A	1940	50.0%

ZIP
Text

Distinct	303
Distinct (%)	15.6%
Missing	0
Missing (%)	0.0%
Memory size	15.3 KiB

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Characters and Unicode

Total characters	9700
Distinct characters	13
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	90 ?
Unique (%)	4.6%

Sample

1st row	98503
2nd row	98188
3rd row	99252
4th row	99201
5th row	98004

Value	Count	Frequency (%)
98004	157	8.1%
98121	107	5.5%
98109	98	5.0%
98005	67	3.5%
98101	43	2.2%
98104	36	1.9%
98119	35	1.8%
98188	30	1.5%
98052	27	1.4%
99224	26	1.3%
Other values (294)	1315	67.7%

Most occurring characters

Value	Count	Frequency (%)
9	2391	24.6%
8	2024	20.9%
0	1392	14.4%
1	1061	10.9%
2	842	8.7%
4	513	5.3%
3	474	4.9%
5	412	4.2%
6	365	3.8%
7	223	2.3%
Other values (3)	3	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	9697	> 99.9%
Uppercase Letter	2	< 0.1%
Space Separator	1	< 0.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
9	2391	24.7%
8	2024	20.9%
0	1392	14.4%
1	1061	10.9%
2	842	8.7%
4	513	5.3%
3	474	4.9%
5	412	4.2%
6	365	3.8%
7	223	2.3%

Uppercase Letter

Value	Count	Frequency (%)
G	1	50.0%
N	1	50.0%

Space Separator

Value	Count	Frequency (%)
	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	9698	> 99.9%
Latin	2	< 0.1%

Most frequent character per script

Common

Value	Count	Frequency (%)
9	2391	24.7%
8	2024	20.9%
0	1392	14.4%
1	1061	10.9%
2	842	8.7%
4	513	5.3%
3	474	4.9%
5	412	4.2%
6	365	3.8%
7	223	2.3%

Latin

Value	Count	Frequency (%)
G	1	50.0%
N	1	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9700	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
9	2391	24.6%
8	2024	20.9%
0	1392	14.4%
1	1061	10.9%
2	842	8.7%
4	513	5.3%
3	474	4.9%
5	412	4.2%
6	365	3.8%
7	223	2.3%
Other values (3)	3	< 0.1%

Groups With Access Code
Categorical

HIGH CORRELATION IMBALANCE

Distinct	5
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	15.3 KiB

Public	1885
Public - Call ahead	29
Public - Credit card at all times	24
Public - Card key after hours	1
Public - Card key at all times	1

Length

Max length	33
Median length	6
Mean length	6.5525773
Min length	6

Characters and Unicode

Total characters	12712
Distinct characters	21
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	0.1%

Sample

1st row	Public
2nd row	Public
3rd row	Public
4th row	Public
5th row	Public

Common Values

Value	Count	Frequency (%)
Public	1885	97.2%
Public - Call ahead	29	1.5%
Public - Credit card at all times	24	1.2%
Public - Card key after hours	1	0.1%
Public - Card key at all times	1	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
public	1940	88.9%
	55	2.5%
call	29	1.3%
ahead	29	1.3%
card	26	1.2%
at	25	1.1%
all	25	1.1%
times	25	1.1%
credit	24	1.1%
key	2	0.1%
Other values (2)	2	0.1%

Most occurring characters

Value	Count	Frequency (%)
l	2048	16.1%
i	1989	15.6%
c	1964	15.4%
u	1941	15.3%
P	1940	15.3%
b	1940	15.3%
	242	1.9%
a	164	1.3%
e	81	0.6%
d	79	0.6%
Other values (11)	324	2.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	10420	82.0%
Uppercase Letter	1995	15.7%
Space Separator	242	1.9%
Dash Punctuation	55	0.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
l	2048	19.7%
i	1989	19.1%
c	1964	18.8%
u	1941	18.6%
b	1940	18.6%
a	164	1.6%
e	81	0.8%
d	79	0.8%
t	75	0.7%
r	52	0.5%
Other values (7)	87	0.8%

Uppercase Letter

Value	Count	Frequency (%)
P	1940	97.2%
C	55	2.8%

Space Separator

Value	Count	Frequency (%)
	242	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	55	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	12415	97.7%
Common	297	2.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
l	2048	16.5%
i	1989	16.0%
c	1964	15.8%
u	1941	15.6%
P	1940	15.6%
b	1940	15.6%
a	164	1.3%
e	81	0.7%
d	79	0.6%
t	75	0.6%
Other values (9)	194	1.6%

Common

Value	Count	Frequency (%)
	242	81.5%
-	55	18.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	12712	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
l	2048	16.1%
i	1989	15.6%
c	1964	15.4%
u	1941	15.3%
P	1940	15.3%
b	1940	15.3%
	242	1.9%
a	164	1.3%
e	81	0.6%
d	79	0.6%
Other values (11)	324	2.5%

Access Days Time
Text

MISSING

Distinct	61
Distinct (%)	3.4%
Missing	162
Missing (%)	8.4%
Memory size	15.3 KiB

Length

Max length	159
Median length	14
Mean length	24.456693
Min length	11

Characters and Unicode

Total characters	43484
Distinct characters	56
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	39 ?
Unique (%)	2.2%

Sample

1st row	24 hours daily
2nd row	24 hours daily; pay lot; Drivers must bring their own J1772 cordset for Level 1 charging
3rd row	24 hours daily; Drivers must bring their own J1772 cordset for Level 1 charging
4th row	24 hours daily
5th row	24 hours daily

Value	Count	Frequency (%)
hours	1643	19.1%
daily	1626	18.9%
24	1612	18.7%
	817	9.5%
10:59pm	658	7.6%
5:00am	644	7.5%
sun	120	1.4%
sat	120	1.4%
fri	117	1.4%
thu	117	1.4%
Other values (110)	1149	13.3%

Most occurring characters

Value	Count	Frequency (%)
	6845	15.7%
a	2706	6.2%
0	2531	5.8%
u	2115	4.9%
r	1946	4.5%
o	1912	4.4%
i	1903	4.4%
s	1885	4.3%
h	1812	4.2%
d	1777	4.1%
Other values (46)	18052	41.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	23436	53.9%
Decimal Number	8998	20.7%
Space Separator	6845	15.7%
Other Punctuation	2424	5.6%
Uppercase Letter	921	2.1%
Dash Punctuation	852	2.0%
Open Punctuation	4	< 0.1%
Close Punctuation	4	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	2706	11.5%
u	2115	9.0%
r	1946	8.3%
o	1912	8.2%
i	1903	8.1%
s	1885	8.0%
h	1812	7.7%
d	1777	7.6%
m	1741	7.4%
l	1731	7.4%
Other values (13)	3908	16.7%

Uppercase Letter

Value	Count	Frequency (%)
S	243	26.4%
T	237	25.7%
F	123	13.4%
M	123	13.4%
W	123	13.4%
D	31	3.4%
J	9	1.0%
L	8	0.9%
U	6	0.7%
C	6	0.7%
Other values (6)	12	1.3%

Decimal Number

Value	Count	Frequency (%)
0	2531	28.1%
2	1679	18.7%
4	1641	18.2%
5	1360	15.1%
1	838	9.3%
9	752	8.4%
7	133	1.5%
6	34	0.4%
8	30	0.3%

Other Punctuation

Value	Count	Frequency (%)
:	1634	67.4%
;	780	32.2%
,	9	0.4%
/	1	< 0.1%

Space Separator

Value	Count	Frequency (%)
	6845	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	852	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	4	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	4	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	24357	56.0%
Common	19127	44.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	2706	11.1%
u	2115	8.7%
r	1946	8.0%
o	1912	7.8%
i	1903	7.8%
s	1885	7.7%
h	1812	7.4%
d	1777	7.3%
m	1741	7.1%
l	1731	7.1%
Other values (29)	4829	19.8%

Common

Value	Count	Frequency (%)
	6845	35.8%
0	2531	13.2%
2	1679	8.8%
4	1641	8.6%
:	1634	8.5%
5	1360	7.1%
-	852	4.5%
1	838	4.4%
;	780	4.1%
9	752	3.9%
Other values (7)	215	1.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	43484	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	6845	15.7%
a	2706	6.2%
0	2531	5.8%
u	2115	4.9%
r	1946	4.5%
o	1912	4.4%
i	1903	4.4%
s	1885	4.3%
h	1812	4.2%
d	1777	4.1%
Other values (46)	18052	41.5%

EV Level1 EVSE Num
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	6
Distinct (%)	75.0%
Missing	1932
Missing (%)	99.6%
Infinite	0
Infinite (%)	0.0%
Mean	22.875

Minimum	1
Maximum	121
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.3 KiB

Quantile statistics

Minimum	1
5-th percentile	1.35
Q1	2
median	3
Q3	17.75
95-th percentile	93
Maximum	121
Range	120
Interquartile range (IQR)	15.75

Descriptive statistics

Standard deviation	41.858392
Coefficient of variation (CV)	1.8298751
Kurtosis	5.5723383
Mean	22.875
Median Absolute Deviation (MAD)	1.5
Skewness	2.3481563
Sum	183
Variance	1752.125
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
2	3	0.2%
121	1	0.1%
1	1	0.1%
10	1	0.1%
4	1	0.1%
41	1	0.1%
(Missing)	1932	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	0.1%
2	3	0.2%
4	1	0.1%
10	1	0.1%
41	1	0.1%
121	1	0.1%

Value	Count	Frequency (%)
121	1	0.1%
41	1	0.1%
10	1	0.1%
4	1	0.1%
2	3	0.2%
1	1	0.1%

EV Level2 EVSE Num
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	17
Distinct (%)	1.0%
Missing	205
Missing (%)	10.6%
Infinite	0
Infinite (%)	0.0%
Mean	2.2910663

Minimum	1
Maximum	44
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.3 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	2
Q3	2
95-th percentile	6
Maximum	44
Range	43
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2.0458994
Coefficient of variation (CV)	0.89299006
Kurtosis	118.53345
Mean	2.2910663
Median Absolute Deviation (MAD)	0
Skewness	8.0520612
Sum	3975
Variance	4.1857045
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
2	1085	55.9%
1	395	20.4%
4	83	4.3%
3	63	3.2%
6	43	2.2%
8	18	0.9%
5	14	0.7%
10	10	0.5%
7	7	0.4%
14	4	0.2%
Other values (7)	13	0.7%
(Missing)	205	10.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	395	20.4%
2	1085	55.9%
3	63	3.2%
4	83	4.3%
5	14	0.7%
6	43	2.2%
7	7	0.4%
8	18	0.9%
9	3	0.2%
10	10	0.5%

Value	Count	Frequency (%)
44	1	0.1%
24	1	0.1%
20	2	0.1%
15	2	0.1%
14	4	0.2%
12	3	0.2%
11	1	0.1%
10	10	0.5%
9	3	0.2%
8	18	0.9%

EV DC Fast Count
Real number (ℝ)

MISSING

Distinct	12
Distinct (%)	4.6%
Missing	1679
Missing (%)	86.5%
Infinite	0
Infinite (%)	0.0%
Mean	3.6934866

Minimum	1
Maximum	20
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.3 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	4
95-th percentile	12
Maximum	20
Range	19
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	3.8508136
Coefficient of variation (CV)	1.0425958
Kurtosis	2.5540044
Mean	3.6934866
Median Absolute Deviation (MAD)	1
Skewness	1.749871
Sum	964
Variance	14.828765
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
1	113	5.8%
4	37	1.9%
2	33	1.7%
8	20	1.0%
3	20	1.0%
12	15	0.8%
6	7	0.4%
16	6	0.3%
10	5	0.3%
5	3	0.2%
Other values (2)	2	0.1%
(Missing)	1679	86.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	113	5.8%
2	33	1.7%
3	20	1.0%
4	37	1.9%
5	3	0.2%
6	7	0.4%
8	20	1.0%
10	5	0.3%
12	15	0.8%
14	1	0.1%

Value	Count	Frequency (%)
20	1	0.1%
16	6	0.3%
14	1	0.1%
12	15	0.8%
10	5	0.3%
8	20	1.0%
6	7	0.4%
5	3	0.2%
4	37	1.9%
3	20	1.0%

EV Network
Categorical

HIGH CORRELATION

Distinct	16
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	15.3 KiB

ChargePoint Network	973
Blink Network	302
Non-Networked	162
Tesla Destination	112
Volta	106
Other values (11)	285

Length

Max length	19
Median length	19
Mean length	15.42268
Min length	3

Characters and Unicode

Total characters	29920
Distinct characters	41
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	0.1%

Sample

1st row	Non-Networked
2nd row	Non-Networked
3rd row	Non-Networked
4th row	Non-Networked
5th row	ChargePoint Network

Common Values

Value	Count	Frequency (%)
ChargePoint Network	973	50.2%
Blink Network	302	15.6%
Non-Networked	162	8.4%
Tesla Destination	112	5.8%
Volta	106	5.5%
SHELL_RECHARGE	58	3.0%
Tesla	49	2.5%
Electrify America	49	2.5%
EV Connect	36	1.9%
eVgo Network	28	1.4%
Other values (6)	65	3.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
network	1303	37.9%
chargepoint	973	28.3%
blink	302	8.8%
non-networked	162	4.7%
tesla	161	4.7%
destination	112	3.3%
volta	106	3.1%
shell_recharge	58	1.7%
america	49	1.4%
electrify	49	1.4%
Other values (9)	165	4.8%

Most occurring characters

Value	Count	Frequency (%)
e	3049	10.2%
o	2896	9.7%
t	2867	9.6%
r	2536	8.5%
k	1767	5.9%
n	1761	5.9%
N	1639	5.5%
i	1597	5.3%
	1500	5.0%
w	1465	4.9%
Other values (31)	8843	29.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	22675	75.8%
Uppercase Letter	5519	18.4%
Space Separator	1500	5.0%
Dash Punctuation	162	0.5%
Connector Punctuation	64	0.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	3049	13.4%
o	2896	12.8%
t	2867	12.6%
r	2536	11.2%
k	1767	7.8%
n	1761	7.8%
i	1597	7.0%
w	1465	6.5%
a	1401	6.2%
g	1001	4.4%
Other values (9)	2335	10.3%

Uppercase Letter

Value	Count	Frequency (%)
N	1639	29.7%
C	1095	19.8%
P	981	17.8%
B	302	5.5%
E	285	5.2%
V	196	3.6%
T	167	3.0%
L	143	2.6%
R	128	2.3%
A	124	2.2%
Other values (9)	459	8.3%

Space Separator

Value	Count	Frequency (%)
	1500	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	162	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	64	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	28194	94.2%
Common	1726	5.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	3049	10.8%
o	2896	10.3%
t	2867	10.2%
r	2536	9.0%
k	1767	6.3%
n	1761	6.2%
N	1639	5.8%
i	1597	5.7%
w	1465	5.2%
a	1401	5.0%
Other values (28)	7216	25.6%

Common

Value	Count	Frequency (%)
	1500	86.9%
-	162	9.4%
_	64	3.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	29920	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	3049	10.2%
o	2896	9.7%
t	2867	9.6%
r	2536	8.5%
k	1767	5.9%
n	1761	5.9%
N	1639	5.5%
i	1597	5.3%
	1500	5.0%
w	1465	4.9%
Other values (31)	8843	29.6%

Latitude
Real number (ℝ)

Distinct	1874
Distinct (%)	96.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	47.465745

Minimum	45.562567
Maximum	48.995255
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.3 KiB

Quantile statistics

Minimum	45.562567
5-th percentile	46.053085
Q1	47.317812
median	47.6146
Q3	47.661538
95-th percentile	48.450226
Maximum	48.995255
Range	3.432688
Interquartile range (IQR)	0.34372575

Descriptive statistics

Standard deviation	0.59883197
Coefficient of variation (CV)	0.012616087
Kurtosis	2.4323527
Mean	47.465745
Median Absolute Deviation (MAD)	0.11255496
Skewness	-1.11402
Sum	92083.545
Variance	0.35859973
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
47.613391	4	0.2%
47.616069	4	0.2%
47.61751	3	0.2%
46.97114	3	0.2%
47.228591	3	0.2%
47.613392	3	0.2%
47.616076	3	0.2%
47.613343	3	0.2%
47.616684	3	0.2%
47.5806355	2	0.1%
Other values (1864)	1909	98.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
45.562567	1	0.1%
45.562604	1	0.1%
45.562907	1	0.1%
45.563002	1	0.1%
45.56304	2	0.1%
45.578726	1	0.1%
45.6040109	1	0.1%
45.606403	1	0.1%
45.609302	1	0.1%
45.615549	1	0.1%

Value	Count	Frequency (%)
48.995255	1	0.1%
48.990486	1	0.1%
48.989751	1	0.1%
48.987053	1	0.1%
48.942575	1	0.1%
48.938283	1	0.1%
48.937845	1	0.1%
48.92653	1	0.1%
48.89416	1	0.1%
48.862062	1	0.1%

Longitude
Real number (ℝ)

Distinct	1891
Distinct (%)	97.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-121.88139

Minimum	-124.66292
Maximum	-117.0435
Zeros	0
Zeros (%)	0.0%
Negative	1940
Negative (%)	100.0%
Memory size	15.3 KiB

Quantile statistics

Minimum	-124.66292
5-th percentile	-122.9096
Q1	-122.37439
median	-122.30086
Q3	-122.17596
95-th percentile	-117.54051
Maximum	-117.0435
Range	7.619428
Interquartile range (IQR)	0.19843075

Descriptive statistics

Standard deviation	1.3768619
Coefficient of variation (CV)	-0.011296736
Kurtosis	4.5748539
Mean	-121.88139
Median Absolute Deviation (MAD)	0.121977
Skewness	2.2717993
Sum	-236449.9
Variance	1.8957486
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-122.346886	2	0.1%
-120.0199	2	0.1%
-122.22728	2	0.1%
-122.3594244	2	0.1%
-122.19644	2	0.1%
-122.21277	2	0.1%
-122.196441	2	0.1%
-122.206519	2	0.1%
-122.331009	2	0.1%
-122.298719	2	0.1%
Other values (1881)	1920	99.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-124.662924	1	0.1%
-124.6600293	1	0.1%
-124.6593683	1	0.1%
-124.5444948	1	0.1%
-124.544249	1	0.1%
-124.3944043	1	0.1%
-124.385236	1	0.1%
-124.3715566	1	0.1%
-124.217215	1	0.1%
-124.216904	1	0.1%

Value	Count	Frequency (%)
-117.043496	1	0.1%
-117.04865	1	0.1%
-117.098183	1	0.1%
-117.098508	1	0.1%
-117.098583	2	0.1%
-117.100062	1	0.1%
-117.102884	1	0.1%
-117.103246	1	0.1%
-117.110447	1	0.1%
-117.112915	1	0.1%

Date Last Confirmed
Categorical

HIGH CORRELATION IMBALANCE

Distinct	26
Distinct (%)	1.3%
Missing	2
Missing (%)	0.1%
Memory size	15.3 KiB

2023-09-29	1452
2023-09-28	147
2022-10-06	112
2023-07-01	46
2022-08-10	27
Other values (21)	154

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	19380
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	0.2%

Sample

1st row	2023-01-10
2nd row	2023-08-10
3rd row	2023-06-12
4th row	2023-04-06
5th row	2023-09-29

Common Values

Value	Count	Frequency (%)
2023-09-29	1452	74.8%
2023-09-28	147	7.6%
2022-10-06	112	5.8%
2023-07-01	46	2.4%
2022-08-10	27	1.4%
2023-06-12	19	1.0%
2023-09-14	18	0.9%
2021-12-09	18	0.9%
2023-05-30	13	0.7%
2023-01-10	12	0.6%
Other values (16)	74	3.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2023-09-29	1452	74.9%
2023-09-28	147	7.6%
2022-10-06	112	5.8%
2023-07-01	46	2.4%
2022-08-10	27	1.4%
2023-06-12	19	1.0%
2023-09-14	18	0.9%
2021-12-09	18	0.9%
2023-05-30	13	0.7%
2023-01-10	12	0.6%
Other values (16)	74	3.8%

Most occurring characters

Value	Count	Frequency (%)
2	5716	29.5%
0	4124	21.3%
-	3876	20.0%
9	3100	16.0%
3	1745	9.0%
1	379	2.0%
8	185	1.0%
6	149	0.8%
7	57	0.3%
4	36	0.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	15504	80.0%
Dash Punctuation	3876	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	5716	36.9%
0	4124	26.6%
9	3100	20.0%
3	1745	11.3%
1	379	2.4%
8	185	1.2%
6	149	1.0%
7	57	0.4%
4	36	0.2%
5	13	0.1%

Dash Punctuation

Value	Count	Frequency (%)
-	3876	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	19380	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	5716	29.5%
0	4124	21.3%
-	3876	20.0%
9	3100	16.0%
3	1745	9.0%
1	379	2.0%
8	185	1.0%
6	149	0.8%
7	57	0.3%
4	36	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	19380	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	5716	29.5%
0	4124	21.3%
-	3876	20.0%
9	3100	16.0%
3	1745	9.0%
1	379	2.0%
8	185	1.0%
6	149	0.8%
7	57	0.3%
4	36	0.2%

ID
Real number (ℝ)

UNIQUE

Distinct	1940
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	189617.41

Minimum	33351
Maximum	311816
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.3 KiB

Quantile statistics

Minimum	33351
5-th percentile	68935.3
Q1	150111.25
median	193611.5
Q3	235327.25
95-th percentile	309375.8
Maximum	311816
Range	278465
Interquartile range (IQR)	85216

Descriptive statistics

Standard deviation	66357.996
Coefficient of variation (CV)	0.3499573
Kurtosis	-0.40172707
Mean	189617.41
Median Absolute Deviation (MAD)	41743.5
Skewness	-0.12025954
Sum	3.6785777 × 10⁸
Variance	4.4033837 × 10⁹
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
33351	1	0.1%
214131	1	0.1%
219848	1	0.1%
219789	1	0.1%
219788	1	0.1%
219758	1	0.1%
218938	1	0.1%
218668	1	0.1%
218510	1	0.1%
218507	1	0.1%
Other values (1930)	1930	99.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
33351	1	0.1%
33717	1	0.1%
35620	1	0.1%
35621	1	0.1%
37181	1	0.1%
38082	1	0.1%
38952	1	0.1%
38959	1	0.1%
38966	1	0.1%
39778	1	0.1%

Value	Count	Frequency (%)
311816	1	0.1%
311815	1	0.1%
311814	1	0.1%
311707	1	0.1%
311665	1	0.1%
311654	1	0.1%
311650	1	0.1%
311642	1	0.1%
311588	1	0.1%
311562	1	0.1%

Updated At
Date

Distinct	842
Distinct (%)	43.4%
Missing	0
Missing (%)	0.0%
Memory size	15.3 KiB

Minimum	2021-03-11 23:22:17+00:00
Maximum	2023-09-29 01:10:29+00:00

Histogram

Histogram with fixed size bins (bins=50)

Open Date
Date

Distinct	877
Distinct (%)	45.2%
Missing	1
Missing (%)	0.1%
Memory size	15.3 KiB

Minimum	2008-02-15 00:00:00
Maximum	2023-09-28 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

EV Connector Types
Categorical

IMBALANCE

Distinct	13
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	15.3 KiB

J1772	1557
CHADEMO J1772COMBO	126
TESLA	112
J1772 TESLA	51
CHADEMO J1772 J1772COMBO	41
Other values (8)	53

Length

Max length	24
Median length	5
Mean length	6.5716495
Min length	5

Characters and Unicode

Total characters	12749
Distinct characters	20
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	0.1%

Sample

1st row	J1772
2nd row	NEMA520
3rd row	J1772 NEMA520
4th row	J1772
5th row	J1772

Common Values

Value	Count	Frequency (%)
J1772	1557	80.3%
CHADEMO J1772COMBO	126	6.5%
TESLA	112	5.8%
J1772 TESLA	51	2.6%
CHADEMO J1772 J1772COMBO	41	2.1%
J1772COMBO	24	1.2%
CHADEMO J1772	18	0.9%
NEMA520	3	0.2%
J1772 NEMA1450	2	0.1%
NEMA1450	2	0.1%
Other values (3)	4	0.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
j1772	1672	75.2%
j1772combo	193	8.7%
chademo	186	8.4%
tesla	163	7.3%
nema520	4	0.2%
nema1450	4	0.2%

Most occurring characters

Value	Count	Frequency (%)
7	3730	29.3%
1	1869	14.7%
2	1869	14.7%
J	1865	14.6%
O	572	4.5%
M	387	3.0%
C	379	3.0%
A	357	2.8%
E	357	2.8%
	282	2.2%
Other values (10)	1082	8.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	7488	58.7%
Uppercase Letter	4979	39.1%
Space Separator	282	2.2%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
J	1865	37.5%
O	572	11.5%
M	387	7.8%
C	379	7.6%
A	357	7.2%
E	357	7.2%
B	193	3.9%
H	186	3.7%
D	186	3.7%
T	163	3.3%
Other values (3)	334	6.7%

Decimal Number

Value	Count	Frequency (%)
7	3730	49.8%
1	1869	25.0%
2	1869	25.0%
5	8	0.1%
0	8	0.1%
4	4	0.1%

Space Separator

Value	Count	Frequency (%)
	282	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	7770	60.9%
Latin	4979	39.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
J	1865	37.5%
O	572	11.5%
M	387	7.8%
C	379	7.6%
A	357	7.2%
E	357	7.2%
B	193	3.9%
H	186	3.7%
D	186	3.7%
T	163	3.3%
Other values (3)	334	6.7%

Common

Value	Count	Frequency (%)
7	3730	48.0%
1	1869	24.1%
2	1869	24.1%
	282	3.6%
5	8	0.1%
0	8	0.1%
4	4	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	12749	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
7	3730	29.3%
1	1869	14.7%
2	1869	14.7%
J	1865	14.6%
O	572	4.5%
M	387	3.0%
C	379	3.0%
A	357	2.8%
E	357	2.8%
	282	2.2%
Other values (10)	1082	8.5%

EV Pricing
Text

MISSING

Distinct	60
Distinct (%)	12.5%
Missing	1460
Missing (%)	75.3%
Memory size	15.3 KiB

Length

Max length	105
Median length	4
Mean length	13.095833
Min length	4

Characters and Unicode

Total characters	6286
Distinct characters	52
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	38 ?
Unique (%)	7.9%

Sample

1st row	Free; 3 hour maximum charging session
2nd row	Free
3rd row	Free
4th row	Free
5th row	Free

Value	Count	Frequency (%)
free	343	31.6%
fee	129	11.9%
parking	107	9.8%
variable	46	4.2%
per	36	3.3%
for	31	2.9%
session	31	2.9%
monthly	26	2.4%
19.99	26	2.4%
or	26	2.4%
Other values (71)	286	26.3%

Most occurring characters

Value	Count	Frequency (%)
e	1046	16.6%
r	688	10.9%
	607	9.7%
F	479	7.6%
0	327	5.2%
a	242	3.8%
$	232	3.7%
n	217	3.5%
.	214	3.4%
i	190	3.0%
Other values (42)	2044	32.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3368	53.6%
Uppercase Letter	928	14.8%
Decimal Number	708	11.3%
Space Separator	607	9.7%
Other Punctuation	394	6.3%
Currency Symbol	232	3.7%
Dash Punctuation	48	0.8%
Math Symbol	1	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1046	31.1%
r	688	20.4%
a	242	7.2%
n	217	6.4%
i	190	5.6%
k	134	4.0%
g	133	3.9%
o	122	3.6%
l	116	3.4%
s	114	3.4%
Other values (13)	366	10.9%

Uppercase Letter

Value	Count	Frequency (%)
F	479	51.6%
P	104	11.2%
H	102	11.0%
E	94	10.1%
V	46	5.0%
R	36	3.9%
W	28	3.0%
L	14	1.5%
D	12	1.3%
C	12	1.3%

Decimal Number

Value	Count	Frequency (%)
0	327	46.2%
1	94	13.3%
5	80	11.3%
9	78	11.0%
2	75	10.6%
4	19	2.7%
7	18	2.5%
3	15	2.1%
8	2	0.3%

Other Punctuation

Value	Count	Frequency (%)
.	214	54.3%
/	124	31.5%
:	26	6.6%
,	22	5.6%
;	8	2.0%

Space Separator

Value	Count	Frequency (%)
	607	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	232	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	48	100.0%

Math Symbol

Value	Count	Frequency (%)
+	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4296	68.3%
Common	1990	31.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1046	24.3%
r	688	16.0%
F	479	11.1%
a	242	5.6%
n	217	5.1%
i	190	4.4%
k	134	3.1%
g	133	3.1%
o	122	2.8%
l	116	2.7%
Other values (24)	929	21.6%

Common

Value	Count	Frequency (%)
	607	30.5%
0	327	16.4%
$	232	11.7%
.	214	10.8%
/	124	6.2%
1	94	4.7%
5	80	4.0%
9	78	3.9%
2	75	3.8%
-	48	2.4%
Other values (8)	111	5.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6286	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	1046	16.6%
r	688	10.9%
	607	9.7%
F	479	7.6%
0	327	5.2%
a	242	3.8%
$	232	3.7%
n	217	3.5%
.	214	3.4%
i	190	3.0%
Other values (42)	2044	32.5%

Auto

Heatmap
Table

	EV Level1 EVSE Num	EV Level2 EVSE Num	EV DC Fast Count	Latitude	Longitude	ID	Groups With Access Code	EV Network	Date Last Confirmed	EV Connector Types
EV Level1 EVSE Num	1.000	-1.000	NaN	-0.464	-0.439	-0.024	0.000	1.000	0.000	0.000
EV Level2 EVSE Num	-1.000	1.000	0.022	0.018	-0.009	0.062	0.065	0.202	0.170	0.000
EV DC Fast Count	NaN	0.022	1.000	0.054	-0.048	-0.059	0.100	0.417	0.307	0.376
Latitude	-0.464	0.018	0.054	1.000	0.062	-0.026	0.073	0.146	0.164	0.102
Longitude	-0.439	-0.009	-0.048	0.062	1.000	-0.062	0.120	0.259	0.236	0.150
ID	-0.024	0.062	-0.059	-0.026	-0.062	1.000	0.202	0.329	0.339	0.244
Groups With Access Code	0.000	0.065	0.100	0.073	0.120	0.202	1.000	0.283	0.589	0.187
EV Network	1.000	0.202	0.417	0.146	0.259	0.329	0.283	1.000	0.552	0.468
Date Last Confirmed	0.000	0.170	0.307	0.164	0.236	0.339	0.589	0.552	1.000	0.444
EV Connector Types	0.000	0.000	0.376	0.102	0.150	0.244	0.187	0.468	0.444	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	Station Name	Street Address	City	State	ZIP	Groups With Access Code	Access Days Time	EV Level1 EVSE Num	EV Level2 EVSE Num	EV DC Fast Count	EV Network	Latitude	Longitude	Date Last Confirmed	ID	Updated At	Open Date	EV Connector Types	EV Pricing
0	City of Lacey - City Hall Parking	420 College St	Lacey	WA	98503	Public	24 hours daily	NaN	4.0	NaN	Non-Networked	47.044011	-122.822404	2023-01-10	33351	2023-02-14 15:54:11 UTC	2018-01-15	J1772	Free; 3 hour maximum charging session
1	Seattle-Tacoma International Airport - General Parking	17801 Pacific Hwy S	Seattle	WA	98188	Public	24 hours daily; pay lot; Drivers must bring their own J1772 cordset for Level 1 charging	121.0	NaN	NaN	Non-Networked	47.443377	-122.296229	2023-08-10	33717	2023-08-10 16:58:49 UTC	2010-03-01	NEMA520	Free
2	Avista Corp	1411 E Mission Ave	Spokane	WA	99252	Public	24 hours daily; Drivers must bring their own J1772 cordset for Level 1 charging	1.0	2.0	NaN	Non-Networked	47.673347	-117.388933	2023-06-12	35620	2023-06-12 16:56:16 UTC	2010-04-15	J1772 NEMA520	Free
3	Steam Plant Parking	130 S Post St	Spokane	WA	99201	Public	24 hours daily	NaN	6.0	NaN	Non-Networked	47.655792	-117.423664	2023-04-06	35621	2023-04-06 17:17:01 UTC	2010-04-15	J1772	Free
4	BELLEVUE BELLEVUE CH 1	450 110th Ave NE	Bellevue	WA	98004	Public	24 hours daily	NaN	2.0	NaN	ChargePoint Network	47.614744	-122.193162	2023-09-29	37181	2023-09-29 00:18:15 UTC	2010-12-15	J1772	NaN
5	KING COUNTY DES ISSAQUAH P&R 2	1755 Highlands Dr NE	Issaquah	WA	98027	Public	24 hours daily	NaN	2.0	NaN	ChargePoint Network	47.545324	-122.019500	2023-09-29	38082	2023-09-29 00:32:33 UTC	2008-02-15	J1772	NaN
6	UWB CASCADIA CC NORTH LEVEL 3 N	18500 Campus Way NE	Bothell	WA	98011	Public	24 hours daily	NaN	2.0	NaN	ChargePoint Network	47.761878	-122.191915	2023-09-29	38952	2023-09-29 00:14:58 UTC	2011-03-15	J1772	NaN
7	CITY OF REDMOND CITY HALL DUAL	15670 NE 85th St	Redmond	WA	98052	Public	24 hours daily	NaN	2.0	NaN	ChargePoint Network	47.679224	-122.129950	2023-09-29	38959	2023-09-29 00:10:28 UTC	2011-03-15	J1772	NaN
8	CITY OF REDMOND MOC #1 PUBLIC	18080 NE 76th St	Redmond	WA	98052	Public	24 hours daily	NaN	2.0	NaN	ChargePoint Network	47.672359	-122.099034	2023-09-29	38966	2023-09-29 00:10:28 UTC	2011-03-15	J1772	NaN
9	Bellingham Nissan	1516 Iowa St	Bellingham	WA	98229	Public - Call ahead	Dealership business hours	NaN	2.0	1.0	Non-Networked	48.755607	-122.454132	2020-06-09	39778	2021-03-11 23:22:17 UTC	2011-03-15	CHADEMO J1772	Free

	Station Name	Street Address	City	State	ZIP	Groups With Access Code	Access Days Time	EV Level1 EVSE Num	EV Level2 EVSE Num	EV DC Fast Count	EV Network	Latitude	Longitude	Date Last Confirmed	ID	Updated At	Open Date	EV Connector Types	EV Pricing
1930	CP RETAIL CUSTPK	7815 S Tacoma Way	Tacoma	WA	98409	Public	24 hours daily	NaN	2.0	NaN	ChargePoint Network	47.185951	-122.482651	2023-09-29	311562	2023-09-29 00:52:54 UTC	2023-09-26	J1772	NaN
1931	FOOTHILLS TOY CT4K	1881 Bouslog Rd	Burlington	WA	98233	Public	24 hours daily	NaN	2.0	NaN	ChargePoint Network	48.449451	-122.346313	2023-09-29	311588	2023-09-29 00:54:25 UTC	2023-09-26	J1772	NaN
1932	1700 Seventh	1700 7th Avenue, Suite 1800	Seattle	WA	98101	Public	Mon 6:00am - 9:00pm; Tue 6:00am - 9:00pm; Wed 6:00am - 9:00pm; Thu 6:00am - 9:00pm; Fri 6:00am - 9:00pm; Sat 9:00am - 9:00pm; Sun 9:00am - 9:00pm	NaN	8.0	NaN	Blink Network	47.614019	-122.335273	2023-09-29	311642	2023-09-29 00:00:42 UTC	2023-06-16	J1772	NaN
1933	Skagit Valley Casino	5984 Darrk Ln	Bow	WA	98232	Public	24 hours daily	NaN	4.0	NaN	SHELL_RECHARGE	48.559758	-122.347134	2023-09-29	311650	2023-09-29 00:59:14 UTC	2023-09-27	J1772	NaN
1934	Sun Mountain Lodge	604 Patterson Lake Rd	Winthrop	WA	98862	Public	24 hours daily	NaN	2.0	NaN	FLO	48.476517	-120.257860	2023-09-29	311654	2023-09-29 01:10:29 UTC	2023-09-27	J1772	NaN
1935	Airmark Apartments/Hotel Interurban	229 Andover Park East	Tukwila	WA	98188	Public	24 hours daily	NaN	2.0	NaN	Blink Network	47.457052	-122.250678	2023-09-28	311665	2023-09-28 23:58:50 UTC	2023-08-02	J1772	NaN
1936	MCREF III Lacey Apartments, LLC	5333 15th Avenue Northeast	Lacey	WA	98516	Public	24 hours daily	NaN	1.0	NaN	Blink Network	47.055925	-122.811905	2023-09-29	311707	2023-09-29 00:04:48 UTC	2023-09-18	J1772	NaN
1937	Moran Prairie Library	6004 S. Regal St	Spokane	WA	99223	Public	NaN	NaN	NaN	2.0	EV Connect	47.599475	-117.369543	2023-09-29	311814	2023-09-29 01:05:05 UTC	2023-09-28	J1772COMBO	NaN
1938	West Valley School	8900 E. Buckeye Ave.	8900 E. Buckeye Ave.	WA	99212	Public	NaN	NaN	NaN	2.0	EV Connect	47.682290	-117.285339	2023-09-29	311815	2023-09-29 01:05:05 UTC	2023-09-28	J1772COMBO	NaN
1939	North Spokane Library	44 E. Hawthorne Rd.	Spokane	WA	99218	Public	NaN	NaN	NaN	2.0	EV Connect	47.750782	-117.409002	2023-09-29	311816	2023-09-29 01:05:05 UTC	2023-09-28	J1772COMBO	NaN

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Math Symbol

Space Separator

Dash Punctuation

Close Punctuation

Open Punctuation

Connector Punctuation

Final Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Punctuation

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Space Separator

Dash Punctuation

Open Punctuation

Close Punctuation

Control

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script